UPDATE purchase_vs_item SET deleted = '1' WHERE purchaseId = '3090'; --UPDATE purchase_vs_investment SET deleted = '1' WHERE purchaseId = '3090'; --UPDATE purchase_vs_expenses SET deleted = '1' WHERE purchaseId = '3090'; --UPDATE purchase_vs_lost SET deleted = '1' WHERE purchaseId = '3090'; --INSERT INTO purchase_vs_item (id, item_id, type_selling, qty, unit_price, selling_price, total_price, cogs_row_amount, purchaseId) VALUES ('', '352', '60', '540', '15', '25', '8100.00', '4250', '3090')  ;--SET @gvpId = LAST_INSERT_ID();--INSERT INTO purchase_vs_item (id, item_id, type_selling, qty, unit_price, selling_price, total_price, cogs_row_amount, purchaseId) VALUES ('', '476', '119', '336', '68', '84', '22848.00', '1700', '3090')  ;--SET @gvpId = LAST_INSERT_ID();--INSERT INTO purchase_vs_item (id, item_id, type_selling, qty, unit_price, selling_price, total_price, cogs_row_amount, purchaseId) VALUES ('', '475', '119', '168', '68', '84', '11424.00', '850', '3090')  ;--SET @gvpId = LAST_INSERT_ID();--INSERT INTO purchase_vs_item (id, item_id, type_selling, qty, unit_price, selling_price, total_price, cogs_row_amount, purchaseId) VALUES ('', '125', '117', '168', '21', '30', '3528.00', '850', '3090')  ;--SET @gvpId = LAST_INSERT_ID();--INSERT INTO purchase_vs_item (id, item_id, type_selling, qty, unit_price, selling_price, total_price, cogs_row_amount, purchaseId) VALUES ('', '477', '119', '168', '15', '40', '2520.00', '850', '3090')  ;--SET @gvpId = LAST_INSERT_ID();--INSERT INTO purchase_vs_expenses (id, provider_id, expenses_account_id, date, amount, purchaseId) VALUES ('', '410', '107', '2026-08-24', '270', '3090')  ;--SET @gvpId = LAST_INSERT_ID();--INSERT INTO purchase_vs_expenses (id, provider_id, expenses_account_id, date, amount, purchaseId) VALUES ('', '396', '11', '2026-08-24', '850', '3090')  ;--SET @gvpId = LAST_INSERT_ID();--INSERT INTO purchase_vs_expenses (id, provider_id, expenses_account_id, date, amount, purchaseId) VALUES ('', '416', '11', '2026-08-24', '7400', '3090')  ;--SET @gvpId = LAST_INSERT_ID();--UPDATE purchase SET code = '', provider_id = '439', shipping = 'ordered', check_mail = '', reference_number = '', terms = '0', provider_email = '', purchase_date = '2026-08-24', due_date = '2026-08-26', bill_date = '0000-00-00', delivered_date = '0000-00-00', general_total_expenses = '8520.00', general_total_price = '48420.00', general_total_selling_price = '67596.00', notes = '', purchase_statement = '', purchase_footer = 'The perishable agricultural commodities listed on this invoice are sold subject to the statutory trust authorized by section 5(c) of the Perishable Agricultural Commodities Act, 1930 (7 U.S.C. 499e(c)). The seller of these commodities retains a trust claim over these commodities, all inventories of food or other products derived from these commodities, and any receivables or proceeds from the sale of these commodities until full payment is received.' WHERE id = '3090'--
	UPDATE purchase 
	SET code = CONCAT('PU',LPAD(id, 6, '0'))
	WHERE purchase.id =  '3090' AND purchase.code = '';
--
   	UPDATE purchase
	SET purchase_date = CURRENT_TIMESTAMP
	WHERE purchase.id = '3090' AND purchase.deleted = '0';
--
   	UPDATE purchase
	SET creation_date = CURRENT_TIMESTAMP
	WHERE purchase.id = '3090' AND purchase.deleted = '0';
--
		INSERT INTO purchase_tracking_mail (purchaseId, email, mail_date, providerId) 
		SELECT 
			purchase.id,               
			purchase.provider_email,   
			CURRENT_TIMESTAMP, 
			purchase.provider_id       
		FROM 
			purchase
		WHERE 
			purchase.id = '3090' AND purchase.check_mail = 'true'
--
    INSERT INTO entity_audit (entity, entity_id, code, action, changes, user_id) 
    SELECT 
    	'purchase' AS entity,
        p.id AS entity_id,
        p.code AS code,  
        'INSERT' AS action,   
        CONCAT('{"userId":', 144, ',"input":[{"elemId":"Purchase created","from":"","to":""}],"mt":[]}') AS changes,          
        144 AS user_id
    FROM 
        purchase p
    WHERE 
        p.id = '3090'

